J. Craig Williams — Smartsheet Community

Skip to content

Overview

Overview
Email	jcwill23@gmail.com
Roles	Member
Badges	35

About Me

About Me
Area of Expertise
About Me	Smartsheet Certified User <br /><br />See:<br />https://ronin-global.com/contact-us-smartsheet-help/<br />to see info about me or how to contact me.<br />The password is "thankyou"<br /><br />Also I have posted tips and tricks for Smartsheet here:<br />https://ronin-global.com/category/smartsheet-help/
How I Use Smartsheet	Daily tasks, any around the house or longer than a few days projects, project management, resource management.
Linkedin	http://www.linkedin.com/in/jcwill23
Twitter Page

Analytics

4,105

Posts

53

Visits

23.8k

Points

Nov 21, 2015

Join Date

Feb 21, 2025

Last Active

Re: How to count number of flags in column?

J. Craig Williams

07/12/16

tobrien3 To get all of them, you'll need to modify Etienne's formula a bit. Hers shows only 10 rows. =COUNTIF([Column15]:[Column15], 1) will show the count of the whole column -- you'll just need to …

1 ·
Re: Formulas- Pulling dollar values from text string

J. Craig Williams

05/04/17

That is because there is an error. =VALUE(RIGHT(Parts1, LEN(Parts1) - FIND("$", Parts1))) FIND returns a number (like 53) and RIGHT takes that many characters from the right. But you want o…

1 ·
Re: Formula - Return month as text from a date cell.

J. Craig Williams

06/13/18

Here's what I do: I have a sheet called "Date Tables". In that sheet I have a column for Month Number and another for Month Name. 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 …

1 ·
Re: PMT calc

J. Craig Williams

10/01/18

This is equation with 4 columns (ignoring two optional args in PMT) =(Pv@row * R@row / IntPer@row) / (1 - (1 + R@row / IntPer@row) ^ (-n@row * IntPer@row)) R = APR % Pv = present value IntPer = inter…

1 ·
Re: Hours of Work Within Task Duration

J. Craig Williams

08/29/18

First, if you follow rquay's suggestion and set the Project Settings first, Smartsheet will ask for if it should create the [Allocation %] column for you. Second, Smartsheet's default working hours p…

1 ·